Skip Headers

Oracle® Database Application Developer's Guide - Large Objects 10g Release 2 (10.2) Part Number B14249-01 |
Home | Book List | Contents | Master Index | Feedback

Previous
| View PDF

# Index

A B C D E F H I J L M N O P R S T U V W

## A

  abstract datatypes and LOBs, 1.8
  access statistics for LOBs, 7.3
  accessing a LOB
    using the LOB APIs, 2.6.3
  accessing external LOBs, 15.2
  amount, 15.13
  amount parameter
    used with BFILEs, 15.7
  appending
    writing to the end of a LOB
      internal persistent LOBs, 14.20
  array read, 14.11
  array write, 14.22
  assigning OCILobLocator pointers, 6.4.5

## B

  BFILE class, See JDBC
  BFILE-buffering, See JDBC
  BFILENAME function, 2.5.2.2, 15.4, 15.5.1
  BFILEs
    accessing, 15.2
    converting to CLOB or NCLOB, 15.7
    creating an object in object cache, 5.5
    datatype, 1.7
    DBMS_LOB read-only procedures, 6.3.8
    DBMS_LOB, offset and amount parameters in bytes, 6.3.2
    hard links and symbolic links not allowed, 3.3.1
    locators, 2.5
    maximum number of open, 3.3.2, 3.3.2, 15.18
    maximum size, 5.6
    multithreaded server, 2.7.2
    multithreaded server mode, 15.6.7
    not affected by LOB storage properties, 4.4.1
    OCI functions to read/examine values, 6.4.9, 6.5.10
    OCI read-only functions, 6.4.11, 6.5.11
    opening and closing using JDBC, 6.9.19
    operating system files, and, 3.3.1
    Oracle Objects for OLE (OO4O)
      opening/closing methods, 6.8.7
      properties, 6.8.11
      read-only methods, 6.8.10
    Pro*C/C++ precompiler statements, 6.6.6
    Pro*COBOL precompiler embedded SQL statements, 6.7.6
    reading with DBMS_LOB, 6.3.6
    rules for using, 3.3.1
    security, 15.5.1, 15.6
    storage devices, 1.4.2
    storing any operating system file, 1.7
    streaming APIs, 6.9.23
    using JDBC to read/examine, 6.9.13
    using Pro*C/C++ precompiler to open and close, 6.6.9
  bind variables, used with LOB locators in OCI, 6.4.6
  binds
    See also INSERT statements and UPDATE statements
  Blob class, 6.5.1.2
  BLOB-buffering, See JDBC
  BLOBs
    class, See JDBC
    datatype, 1.7
    DBMS_LOB, offset and amount parameters in bytes, 6.3.2
    modify using DBMS_LOB, 6.3.5
    using JDBC to modify, 6.9.7
    using JDBC to read/examine BLOB values, 6.9.8
    using oracle.sql.BLOB methods to modify, 6.9.7
  buffering
    disable
      internal persistent LOBs, 14.27
    enable
      internal persistent LOBs, 14.25
    flush
      internal persistent LOBs, 14.26
    LOB buffering subsystem, 5.1.3.2

## C

  C++, See Pro*C/C++ precompiler
  C, See OCI
  CACHE / NOCACHE, 4.4.7
  caches
    object cache, 5.5
  callback, 14.10, 14.20, 15.13
  CAST, 10.3
  catalog views
    v$temporary_lobs, 3.2
  character data
    varying width, 4.2.2
  character set ID, 6.3.3
    getting the
      internal persistent LOBs, 14.4
    See CSID parameter
  charactersets
    multibyte, LONG and LOB datatypes, 13.4.3
  CHUNK, 4.4.9, 5.6.1
  chunk size, 14.21
    and LOB storage properties, 4.4.1
    multiple of, to improve performance, 14.10
  CLOB class, See JDBC
  CLOB-buffering, See JDBC
  CLOBs
    columns
      varying- width character data, 4.2.2
    datatype, 1.7
      varying-width columns, 4.2.2
    DBMS_LOB, offset and amount parameters in characters, 6.3.2
    modify using DBMS_LOB, 6.3.5
    opening and closing using JDBC, 6.9.18
    reading/examining with JDBC, 6.9.11
    using JDBC to modify, 6.9.10
  Clone method, See Oracle Objects for OLE (OO4O)
  closing
    all open BFILEs, 15.24
    BFILEs with CLOSE, 15.23
    BFILEs with FILECLOSE, 15.22
  clustered tables, 11.5.1
  COBOL, See Pro*COBOL precompiler
  codepoint semantics, 9.2.2
  comparing
    all or part of two LOBs
      internal persistent LOBs, 14.13
    all or parts of two BFILEs, 15.15
  conventional path load, 3.1.1
  conversion
    explicit functions for PL/SQL, 10.3
  conversion, implicit from CLOB to character type, 9.2
  conversions
    character set, 15.7
    from binary data to character set, 15.7
    implicit, between CLOB and VARCHAR2, 10.2
  converting
    to CLOB, 10.3
  copy semantics, 1.6
    internal LOBs, 8.3
  copying
    all or part of a LOB to another LOB
      internal persistent LOBs, 14.16
    LOB locator
      internal persistent LOBs, 14.17
    LOB locator for BFILE, 15.19
  CSID parameter
    setting OCILobRead and OCILobWrite to OCI_UCS2ID, 6.4.1

## D

  data interface for persistent LOBs, 13
    multibyte charactersets, 13.4.3
  data interface for remote LOBs, 13.6
  data interface in Java, 13.5
  DBMS_LOB
    updating LOB with bind variable, 5.3.6
    WRITE()
      passing hexadecimal string to, 14.21
  DBMS_LOB functions on a NULL LOB restriction, 4.1.1.1
  DBMS_LOB package
    available LOB procedures/functions, 6.2, 6.2
    for temporary LOBs, 6.3.7
    functions/procedures to modify BLOB, CLOB, and NCLOB, 6.3.5
    functions/procedures to read/examine internal and external LOBs, 6.3.6
    LOADBLOBFROMFILE, 15.7
    LOADCLOBFROMFILE, 15.7
    LOADFROMFILE(), 15.7
    multithreaded server, 2.7.2
    multithreaded server mode, 15.6.7
    offset and amount parameter guidelines, 6.3.2
    open and close, JDBC replacements for, 6.9.16
    opening/closing internal and external LOBs, 6.3.9
    provide LOB locator before invoking, 6.3.1
    read-only functions/procedures for BFILEs, 6.3.8
    to work with LOBs, using, 6.3
    WRITE()
      guidelines, 14.21
  DBMS_LOB.GET_STORAGE_LIMIT, 5.6.3
  DBMS_LOB.GETCHUNKSIZE, 5.6.1
  DBMS_LOB.GETLENGTH return value, 9.2.4
  DBMS_LOB.isTemporary, previous workaround for JDBC, 14.28.1
  DBMS_LOB.LOADBLOBFROMFILE, 6.3.2
  DBMS_LOB.LOADCLOBFROMFILE, 6.3.2
  DBMS_LOB.LOADFROMFILE, 6.3.2
  DBMS_LOB.READ, 15.13
  directories
    catalog views, 15.6.5
    guidelines for usage, 15.6.6
    ownership and privileges, 15.6.1
  DIRECTORY name specification, 15.5.1
  DIRECTORY object
    catalog views, 15.6.5
    getting the alias and filename, 15.20
    guidelines for usage, 15.6.6
    names on Windows platforms, 15.5.1.1
    naming convention, 15.5.1
    READ permission on object not individual files, 15.6.2
    rules for using, 3.3.1
    symbolic links, 3.3.1
    symbolic links, and, 3.3.1
  DIRECTORY objects, 15.3
  direct-path load, 3.1.1
  displaying
    LOB data for internal persistent LOBs, 14.9
  domain indexing on LOB columns, 4.5.1

## E

  embedded SQL statements, See Pro*C/C++ precompiler and Pro*COBOL precompiler
  empty LOBs
    creating using JDBC, 6.9.24
    JDBC, 6.9.24
  EMPTY_BLOB() and EMPTY_CLOB, LOB storage properties for, 4.4.1
  EMPTY_CLOB()/BLOB()
    to initialize internal LOB, 2.5.2.1
  equal
    one LOB locator to another
      internal persistent LOBs, 14.18
  erasing
    part of LOB
      internal persistent LOBs, 14.24
  error message documentation, database, Preface
  example, LOB access statistics, 7.3.1
  examples
    repercussions of mixing SQL DML with DBMS_LOB, 5.3.4
    updated LOB locators, 5.3.5
    updating a LOB with a PL/SQL variable, 5.3.6
  existence
    check for BFILE, 15.17
  extensible indexes, 4.5.3
  external callout, 5.1.5
  external LOBs (BFILEs)
    See BFILEs
  external LOBs (BFILEs), See BFILEs

## F

  FILECLOSEALL(), 15.6.6
  flushing
    LOB buffer, 5.1.4
  flushing buffer, 5.1.1
  FOR UPDATE clause
    LOB locator, 5.3.1
  function-based indexes, 4.5.3
  function-based indexes on LOB columns, 4.5.3

## H

  hard links, rules with BFILEs, 3.3.1
  hexadecimal string
    passing to DBMS_LOB.WRITE(), 14.21

## I

  implicit assignment and parameter passing for LOB columns, 13.3.2
  implicit conversion of CLOB to character type, 9.2
  Improved LOB Usability, Accessing LOBs Using SQL Character Functions, 9.1
  indexes
    function-based, 4.5.3
    rebuilding after LONG-to-LOB migration, 11.5.3
  indexes on LOB columns
    bitmap index not supported, 4.5.1
    B-tree index not supported, 4.5.1
    domain indexing, 4.5.1
  indexes, restrictions, 11.5.3
  index-organized tables, restrictions for LOB columns, 4.8
  initializing
    during CREATE TABLE or INSERT, 8.4
    using EMPTY_CLOB(), EMPTY_BLOB(), 2.5.2.1
  initializing a LOB column to a non-null value, 4.1.1.2
  inline storage, 4.4.1
  inline storage, maximum size, 4.4.1
  INSERT statements
    binds of greater than 4000 bytes, 13.3.7
  inserting
    a row by initializing a LOB locator
      internal persistent LOBs, 8.5
    a row by initializing BFILE locator, 15.25
  interfaces for LOBs, see programmatic environments
  IS NULL return value for LOBs, 9.5.2
  IS NULL usage with LOBs, 9.5.2

## J

  Java, See JDBC
  java.sql.Blob, 6.9.1
  java.sql.Clob, 6.9.1
  JDBC
    available LOB methods/properties, 6.2
    BFILE class
    BFILE streaming APIs, 6.9.23
    BFILE-buffering, 6.9.14
    BLOB and CLOB classes
    calling DBMS_LOB package, 6.9.3
    checking if BLOB is temporary, 14.28.1
    CLOB streaming APIs, 6.9.22
    empty LOBs, 6.9.24
    encapsulating locators
    methods/properties for BLOB-buffering, 6.9.9
    methods/properties for CLOB-buffering, 6.9.12
    modifying BLOB values, 6.9.7
    modifying CLOB values, 6.9.10
    modifyng internal LOBs with Java using objects oracle.sql.BLOB/CLOB, 6.9.1
    newStreamLob.java, 6.9.23.1
    opening and closing BFILEs, 6.9.19
    opening and closing CLOBs, 6.9.18
    opening and closing LOBs, 6.9.16
    reading internal LOBs and external LOBs (BFILEs) with Java, 6.9.2
    reading/examining BLOB values, 6.9.8
    reading/examining CLOB values, 6.9.11
    reading/examining external LOB (BFILE) values, 6.9.13
    referencing LOBs, 6.9.4
    streaming APIs for LOBs, 6.9.21
    syntax references, 6.9.5
    trimming LOBs, 6.9.20
    using OracleResultSet to reference LOBs, 6.9.4.1
    using OUT parameter from OraclePreparedStatement to reference LOBs, 6.9.4.1
    writing to empty LOBs, 6.9.24
  JDBC 3.0, 6.9.1
  JDBC and Empty LOBs, 6.9.24

## L

  LBS, See Lob Buffering Subsystem (LBS)
  length
    an internal persistent LOB, 14.15
    getting BFILE, 15.18
  LENGTH return value for LOBs, 9.2.4
  loading
    a LOB with BFILE data, 15.7
    LOB with data from a BFILE, 14.5
  LOB attributes
    defined, 1.8
  LOB buffering
    BLOB-buffering with JDBC, 6.9.9
    buffer-enabled locators, 5.1.6
    example, 5.1.3.2
    flushing the buffer, 5.1.4
    flushing the updated LOB through LBS, 5.1.5
    guidelines, 5.1.2
    OCI example, 5.1.8
    OCI functions, 6.4.13
    OCILobFlushBuffer(), 5.1.4
    Oracle Objects for OLE (OO4O)
      methods for internal LOBs, 6.8.8
    physical structure of buffer, 5.1.3.1
    Pro*C/C++ precompiler statements, 6.6.8
    Pro*COBOL precompiler statements, 6.7.8
    usage notes, 5.1.3
  LOB Buffering SubSystem (LBS)
  LOB Buffering Subsystem (LBS)
    advantages, 5.1.1
    buffer-enabled locators, 5.1.5
    buffering example using OCI, 5.1.8
    example, 5.1.3.2
    flushing
      updated LOB, 5.1.5
    flushing the buffer, 5.1.4
    guidelines, 5.1
    saving the state of locator to avoid reselect, 5.1.7
    usage, 5.1.3
  LOB columns
    initializing internal LOB to a value, 4.1.3
    initializing to contain locator, 2.5.2
    initializing to NULL or Empty, 4.1.1
  LOB locator
    copy semantics, 1.6
    external LOBs (BFILEs), 1.6
    internal LOBs, 1.6
    out-bind variables in OCI, 6.4.6
    reference semantics, 1.6
  LOB locators, always stored in row, 4.4.1
  LOB reads, 7.3
  LOB storage
    format of varying width character data, 4.2.2
    inline and out-of-line storage properties, 4.4.1
  LOB writes, 7.3
  LOB writes unaligned, 7.3
  LOBs
    abstract datatypes, members of, 1.8
    attributes and abstract datatypes, 1.8
    attributes and object cache, 5.5
    buffering
      caveats, 5.1.1
      pages can be aged out, 5.1.4
    buffering subsystem, 5.1
    buffering usage notes, 5.1.3
    datatypes versus LONG, 1.3
    external (BFILEs), 1.4.2
    flushing, 5.1.1
    in partitioned tables, 4.6
    in the object cache, 5.5
    interfaces, See programmatic environments
    interMEDIA, 1.9.3
    internal
      creating an object in object cache, 5.5
    internal LOBs
      CACHE / NOCACHE, 4.4.7
      CHUNK, 4.4.9
      ENABLE | DISABLE STORAGE IN ROW, 4.4.10
      initializing, 15.13
      introduced, 1.4.1
      locators, 2.5
      locking before updating, 14.2, 14.16, 14.20, 14.21, 14.23, 14.24
      LOGGING / NOLOGGING, 4.4.8
      Oracle Objects for OLE (OO4O), modifying methods, 6.8.5
      PCTVERSION, 4.4.5, 4.4.5
      setting to empty, 4.1.1.2
      tablespace and LOB index, 4.4.4
      tablespace and storage characteristics, 4.4.2
      transactions, 1.4.1
    locators, 2.5, 5.3.1
    maximum sizes allowed, 5.6
    object cache, 5.5
    piecewise operations, 5.3.3
    read consistent locators, 5.3.1
    reason for using, 1.2
    setting to contain a locator, 2.5.2
    setting to NULL, 4.1.1.1
    tables
      creating indexes, 4.6.2
      moving partitions, 4.6.3
      splitting partitions, 4.6.4
    unstructured data, 1.2.2
    updated LOB locators, 5.3.3
    varying-width character data, 4.2.3
  LOBs, data interface for remote, 13.6
  LOBs, data interface in Java, 13.5
  locators, 2.5
    BFILEs, 15.6.8
      guidelines, 15.6.8.3
      two rows can refer to the same file, 15.6.8.1
    buffer-enabled, 5.1.6
    external LOBs (BFILEs), 2.5
    LOB, cannot span transactions, 5.4.4
    multiple, 5.3.1
    OCI functions, 6.4.12, 6.5.12
    Pro*COBOL precompiler statements, 6.7.7
    providing in Pro*COBOL precompiler, 6.7.1
    read consistent, 5.1.4, 5.1.7, 5.1.7, 5.3.1, 5.3.6, 5.4.4
    read consistent locators, 5.3.1
    read consistent, updating, 5.3.1
    reading and writing to a LOB using, 5.4.1
    saving the state to avoid reselect, 5.1.7
    see if LOB locator is initialized
      internal persistent LOBs, 14.19
    selecting within a transaction, 5.4.3
    selecting without current transaction, 5.4.2
    setting column to contain, 2.5.2
    transaction boundaries, 5.4
    updated, 5.1.4, 5.3.3, 5.3.6
    updating, 5.4.4
  LOGGING
    migrating LONG-to-LOBs, 11.2.2
  LOGGING / NOLOGGING, 4.4.8
  LONG versus LOB datatypes, 1.3
  LONG-to-LOB Migration, 11.1
  LONG-to-LOB migration
    ALTER TABLE, 11.4.1
    clustered tables, 11.5.1
    LOGGING, 11.2.2
    NULLs, 11.5.4
    rebuilding indexes, 11.5.3
    replication, 11.1
    triggers, 11.5.2
  lONG-to-LOB migration
    PL/SQL, 13.3.1

## M

  migrating
    LONG to LOBs, see LONG-to-LOB, 11.1
    LONG-to-LOB using ALTER TABLE, 11.4.1
    LONG-to-LOBs, constraints maintained, 11.4.1.1
    LONG-to-LOBs, indexing, 11.5.3
  migration of LONG to LOB in parallel, 11.4.3
  multibyte character sets, using with the data interface for LOBs, 13.4.3
  multithreaded server
    BFILEs, 2.7.2, 15.6.7, 15.6.7

## N

  national language support
    NCLOBs, 1.7
  NCLOB parameters allowed as attributes, Preface
  NCLOBs
    datatype, 1.7
    DBMS_LOB, offset and amount parameters in characters, 6.3.2
    modify using DBMS_LOB, 6.3.5
  NewStreamLob.java, 6.9.23.1
  NLS_CHARSET_ID, 6.3.3
  NOCOPY, using to pass temporary LOB parameters by reference, 7.1.4
  ISNULL usage with LOBs, 9.5.2
  NULL LOB value, LOB storage for, 4.4.1
  NULL LOB values, LOB storage properties for, 4.4.1
  NULL LOB, restrictions calling OCI and DBMS_LOB functions, 4.1.1.1

## O

  object cache, 5.5
    creating an object in, 5.5
    LOBs, 5.5
  OCCI
    compared to other interfaces, 6.2
    LOB functionality, 6.5
  OCCI Bfile class, 6.5.11
  OCCI Blob class
    read, 6.5.3
    write, 6.5.3
  OCCI Clob class, 6.5.1
    read, 6.5.3
    write, 6.5.3
  OCI
    available LOB functions, 6.2
    character set rules, fixed-width and varying-width, 6.4.2
    functions for BFILEs, 6.4.11, 6.5.11
    functions for temporary LOBs, 6.4.10, 6.5.11
    functions to modify internal LOB values, 6.4.8, 6.5.9
    functions to open/close internal and external LOBs, 6.4.14, 6.5.13
    functions to read or examine internal and external LOB values, 6.4.9, 6.5.10
    LOB buffering example, 5.1.8
    LOB locator functions, 6.4.12, 6.5.12
    Lob-buffering functions, 6.4.13
    NCLOB parameters, 6.4.2.2, 6.5.4.1
    OCILobFileGetLength
      CLOB and NCLOB input and output length, 6.4.2
    OCILobRead2()
      varying-width CLOB and NCLOB input and amount amounts, 6.4.2
    OCILobWrite2()
      varying-width CLOB and NCLOB input and amount amounts, 6.4.2, 6.5.3
    offset and amount parameter rules
      fixed-width character sets, 6.5.2
    setting OCILobRead2(), OCILobWrite2() to OCI_UCS2ID, 6.4.1
    using to work LOBs, 6.4
  OCI functions on a NULL LOB restriction, 4.1.1.1
  OCILobArrayRead(), 14.11
  OCILobArrayWrite(), 14.22
  OCILobAssign(), 5.1.2
  OCILobFileSetName(), 15.5, 15.6.8.3
  OCILobFlushBuffer(), 5.1.4
  OCILobGetChunkSize(), 5.6.1, 5.6.4
  OCILobGetStorageLimit(), 5.6.4
  OCILobLoadFromFile(), 15.7, 15.7
  OCILobLocator in assignment "=" operations, 6.4.5
  OCILobLocator, out-bind variables, 6.4.6
  OCILobRead2(), 14.9, 14.10, 15.13
    BFILEs, 15.13
  OCILobWriteAppend2(), 14.20
  OCIObjectFlush(), 15.6.8.3
  OCIObjectNew(), 15.6.8.3
  OCISetAttr(), 15.6.8.3
  offset parameter, in DBMS_LOB operations, 6.3.2
  OLEDB, 6.10
  OO4O, See Oracle Objects for OLE (OO4O)
  open
    checking for open BFILEs with FILEISOPEN(), 15.11
    checking if BFILE is open with ISOPEN, 15.10
  open, determining whether a LOB is open, 14.8
  OpenCloseLob.java example, 6.9.19.4
  opening
    BFILEs using FILEOPEN, 15.9
    BFILEs with OPEN, 15.8
  opening and closing LOBs
    using JDBC, 6.9.16
  ORA-17098
    empty LOBs and JDBC, 6.9.24
  OraBfile, See Oracle Objects for OLE (OO4O)
  OraBlob, See Oracle Objects for OLE (OO4O)
  Oracle Call Interface, See OCI
  Oracle Objects for OLE (OO4O)
    available LOB methods/properties, 6.2
    internal LOB buffering, 6.8.8
    methods and properties to access data stored in BLOBs, CLOBs, NCLOBs, and BFILEs, 6.8.4
    modifying internal LOBs, 6.8.5
    opening/closing external LOBs (BFILEs), 6.8.7
    OraBfile example
    OraBlob example
    OraBlob, OraClob, and OraBfile encapsulate locators, 6.8.2
    properties for operating on external LOBs (BFILEs), 6.8.11
    properties for operating on LOBs, 6.8.9
    reading/examining internal LOB and external LOB (BFile) values, 6.8.6
    read-only methods for external LOBs (BFILEs), 6.8.10
    syntax reference, 6.8.1
    using Clone method to retain locator independent of dynaset, 6.8.2.2
  OraclePreparedStatement, See JDBC
  OracleResultSet, See JDBC
  oracle.sql.BFILE
    BFILE-buffering, 6.9.14
    JDBC methods to read/examine BFILEs, 6.9.13
  oracle.sql.BLOB
    for modifying BLOB values, 6.9.7
    reading/examining BLOB values, 6.9.8
    See JDBC
  oracle.sql.BLOBs
    BLOB-buffering
  oracle.sql.CLOB
    CLOB-buffering
    JDBC methods to read/examine CLOB values, 6.9.11
    modifying CLOB values, 6.9.10
  oracle.sql.CLOBs
    See JDBC
  OraOLEDB, 6.10
  out-of-line storage, 4.4.1

## P

  parallel DML support, 13.3.11
  parallel LONG-to-LOB migration, 11.4.3
  partitioned index-organized tables
    restrictions for LOB columns, 4.8
  pattern
    check if it exists in BFILE using instr, 15.16
    see if it exists IN LOB using (instr)
      internal persistent LOBs, 14.14
  PCTINCREASE parameter, recommended value for LOBs, 5.7.1
  PCTVERSION, 4.4.5, 4.4.5
  performance
    guidelines
      reading/writing large data chunks, 7.1.3
      reading/writing large data chunks, temporary LOBs, 7.1.4
  PL/SQL, 6.1
    and LOBs, semantics changes, 10.1
    changing locator-data linkage, 10.3.1
    CLOB variables in, 10.3.1
    CLOB variables in PL/SQL, 10.3.1
    CLOB versus VARCHAR2 comparison, 10.4
    CLOBs passed in like VARCHAR2s, 10.3.1
    defining a CLOB Variable on a VARCHAR, 10.2
    freeing temporary LOBs automatically and manually, 10.3.1
    using in LONG-to-LOB migration, 13.3.1
  PM schema, 2.5.1
  polling, 14.10, 14.20, 15.13
  print_media creation, 8.1
  print_media table definition, 2.5.1
  Pro*C/C++ precompiler
    available LOB functions, 6.2, 6.2
    LOB buffering, 6.6.8
    locators, 6.6.7
    modifying internal LOB values, 6.6.3
    opening and closing internal LOBs and external LOBs (BFILEs), 6.6.9
    providing an allocated input locator pointer, 6.6.1
    reading or examining internal and external LOB values, 6.6.4
    statements for BFILEs, 6.6.6
    statements for temporary LOBs, 6.6.5
  Pro*COBOL precompiler
    available LOB functions, 6.2
    LOB buffering, 6.7.8
    locators, 6.7.7
    modifying internal LOB values, 6.7.3
    providing an allocated input locator, 6.7.1
    reading or examining internal and external LOBs, 6.7.4
    statements for BFILEs, 6.7.6
    temporary LOBs, 6.7.5
  programmatic environments
    available functions, 6.2
    compared, 6.2
  programmatic environments for LOBs, 6.1

## R

  read consistency
    LOBs, 5.3.1
  read consistent locators, 5.1.4, 5.1.7, 5.1.7, 5.3.1, 5.3.6, 5.4.4
  reading
    data from a LOB
      internal persistent LOBs, 14.10
    large data chunks, performance guidelines, 7.1.3
    large data chunks, temporary LOBs, 7.1.4
    portion of BFILE data using substr, 15.14
    portion of LOB using substr
      internal persistent LOBs, 14.12
    small amounts of data, enable buffering, 14.25
  reference semantics, 8.3, 8.3
    BFILEs enables multiple BFILE columns for each record, 15.4
  replication, 11.1
  restrictions
    binds of more than 4000 bytes, 13.3.10
    cannot call OCI or DBMS_LOB functions on a NULL LOB, 4.1.1.1
    clustered tables, 11.5.1
    indexes, 11.5.3
    index-organized tables and LOBs, 4.8
    on LOBs, 2.7
    removed, Preface
    replication, 11.1
    triggers, 11.5.2
  retrieving LOB access statistics, 7.3.1
  RETURNING clause, using with INSERT to initialize a LOB, 4.1.1.2
  round-trips to the server, avoiding, 5.1.1, 5.1.7
  rules for using directory objects and BFILEs, 3.3.1

## S

  sample schema for examples, 8.1
  security
    BFILEs, 15.5.1, 15.6
    BFILEs using SQL DDL, 15.6.3
    BFILEs using SQL DML, 15.6.4
  SELECT statement
    read consistency, 5.3.1
  semantics
    copy-based for internal LOBs, 8.3
    reference based for BFILEs, 15.4
  SESSION_MAX_OPEN_FILES parameter, 3.3.2, 3.3.2
  setting
    internal LOBs to empty, 4.1.1.2
    LOBs to NULL, 4.1.1.1
    overrides for NLS_LANG variable
  SQL
    Character Functions, improved, 9.1
    features where LOBs cannot be used, 9.4
  SQL DDL
    BFILE security, 15.6.3
  SQL DML
    BFILE security, 15.6.4
  SQL functions on LOBs
    return type, 9.2.3
    return value, 9.2.3
    temporary LOBs returned, 9.2.3
  SQL semantics and LOBs, 9.4
  SQL semantics supported for use with LOBs, 9.2
  SQL*Loader
    conventional path load, 3.1.1
    direct-path load, 3.1.1
  statistics, access, 7.3
  streaming, 14.9
    do not enable buffering, when using, 14.25
    write, 14.21
  streaming APIs
    NewStreamLob.java, 6.9.23.1
    using JDBC and BFILEs, 6.9.23
    using JDBC and CLOBs, 6.9.22
    using JDBC and LOBs, 6.9.21
  symbolic links, rules with DIRECTORY objects and BFILEs, 3.3.1
  system owned object, See DIRECTORY object

## T

  temporary BLOB
    checking if temporary using JDBC, 14.28.1
  temporary LOBs
    checking if LOB is temporary, 14.28
    DBMS_LOB available functions/procedures, 6.3.7
    OCI functions, 6.4.10, 6.5.11
    Pro*C/C++ precompiler embedded SQL statements, 6.6.5
    Pro*COBOL precompiler statements, 6.7.5
    returned from SQL functions, 9.2.3
  TO_BLOB(),TO_CHAR(), TO_NCHAR(), 10.3
  TO_CHAR(), 10.3
  TO_CLOB()
    converting VARCHAR2,NVARCHAR2,NCLOB to CLOB, 10.3
  TO_NCLOB(), 10.3
  transaction boundaries
    LOB locators, 5.4
  transaction IDs, 5.4.1
  transactions
    external LOBs do not participate in, 1.5
    IDs of locators, 5.4
    internal LOBs participate in database transactions, 1.4.1
    LOB locators cannot span, 5.4.4
    locators with non-serializable, 5.4.1
    locators with serializable, 5.4.1
    migrating from, 5.1.5
  triggers
    LONG-to-LOB migration, 11.5.2
  trimming
    LOB data
      internal persistent LOBs, 14.23
  trimming LOBs using JDBC, 6.9.20

## U

  UB8MAXVAL is BFILE maximum size, 5.6
  UCS2 Unicode character set
    varying width character data, 4.2.2
  UNICODE
    VARCHAR2 and CLOBs support, 9.2.1
  unstructured data, 1.2.2
  UPDATE statements
    binds of greater than 4000 bytes, 13.3.7
  updated locators, 5.1.4, 5.3.3, 5.3.6
  updating
    avoid the LOB with different locators, 5.3.5
    LOB values using one locator, 5.3.5
    LOB values, read consistent locators, 5.3.1
    LOB with PL/SQL bind variable, 5.3.6
    LOBs using SQL and DBMS_LOB, 5.3.4
    locators, 5.4.4
    locking before, 14.16
    locking prior to, 14.2, 14.23, 14.24

## V

  V$NLS_VALID_VALUES, 6.3.3
  VARCHAR2
    accessing CLOB data when treated as, 10.2
    also RAW, applied to CLOBs and BLOBs, 9.5
    defining CLOB variable on, 10.2
  VARCHAR2, using SQL functions and operators with LOBs, 9.2
  VARRAY
    LOB restriction, 2.7.1
  varying-width character data, 4.2.2
  views on DIRECTORY object, 15.6.5
  Visual Basic, See Oracle Objects for OLE(OO4O)

## W

  WHERE Clause Usage with LOBs, 9.5.3
  writing
    data to a LOB
      internal persistent LOBs, 14.21
    large data chunks, performance guidelines, 7.1.3
    large data chunks, temporary LOBs, 7.1.4
    singly or piecewise, 14.20
    small amounts of data, enable buffering, 14.25